package org.alvin;

public class SqlTest {

//    public static void main(String [] args){
//        String text ="CC\t基本信息录入\tbasic info entry\n" +
//                "BI\t长期改善措施\tlong-term solution\n" +
//                "CC\t效果验证\teffect test\n" +
//                "BI\t质量经理审批\tapproval by quality manager\n" +
//                "BI\t风险评估\tthe risk assessment\n" +
//                "BI\t基本信息录入\tbasic info entry\n" +
//                "IQCF\t基本信息录入\tbasic info entry\n" +
//                "CC\t长期改善措施\tlong-term solution\n" +
//                "AQC\t制定跟踪方案\tinitiate Follow-up plan\n" +
//                "XCSA\t基本信息录入\tbasic info entry\n" +
//                "VLRR\t基本信息录入\tbasic info entry\n" +
//                "BI\t短期改善措施\tshort-term solution\n" +
//                "XCSA\t风险评估\tthe risk assessment\n" +
//                "CC\t制定跟踪方案\tinitiate Follow-up plan\n" +
//                "QH\tcqe解除\tCQE remove\n" +
//                "BI\t效果验证\teffect test\n" +
//                "CC\tWW CQM确认\tWW CQM-confirm Solution\n" +
//                "CC\t质量经理审批\tapproval by quality manager\n" +
//                "PD\t效果验证\teffect test\n" +
//                "BI\t结案\tclose the case\n" +
//                "AQC\t长期改善措施一级审批\tLevel 1 Approval for Long-term Solution\n" +
//                "CC\t结案\tclose the case\n" +
//                "PC\t发起流程\tINITIATE THE PROCESS\n" +
//                "PC\t部门经理审批\tDEPARTMENT MANAGER APPROVAL\n" +
//                "PC\tQA审批\tQA APPROVAL\n" +
//                "RWK\t发起返工\tcreate rework\n" +
//                "RWK\t完成返工\tcomplete the rework\n" +
//                "RWK\t确认返工基本信息\tconfirm rework basic information\n" +
//                "PC\tIPQC结案\tIPQC CASE-CLOSING\n" +
//                "PD\t项目申请\tcase initiator\n" +
//                "PD\t项目改善\tproject improvement\n" +
//                "PD\t审核人评审\tauditor review\n" +
//                "PD\t评审组评审\tproject review group review\n" +
//                "QH\towner确认\towner confirm\n" +
//                "QH\tpqe解除\tPQE remove\n" +
//                "QH\towner反馈影响范围\towner impact scope\n" +
//                "RWK\t下发返工MO确认\tdeliver rework MO\n" +
//                "FPY\t基本信息录入\tbasic info entry\n" +
//                "AQC\t基本信息录入\tbasic info entry\n" +
//                "FQC\t基本信息录入\tbasic info entry\n" +
//                "LRR\t基本信息录入\tbasic info entry\n" +
//                "BI\t长期改善措施一级审批\tLevel 1 Approval for Long-term Solution\n" +
//                "CC\t长期改善措施一级审批\tLevel 1 Approval for Long-term Solution\n" +
//                "IQCF\t短期改善措施\tshort-term solution\n" +
//                "VLRR\t短期改善措施\tshort-term solution\n" +
//                "TPY\t短期改善措施\tshort-term solution\n" +
//                "BI\t制定跟踪方案\tinitiate Follow-up plan\n" +
//                "OOB\t短期改善措施\tshort-term solution\n" +
//                "OOB\t制定跟踪方案\tinitiate Follow-up plan\n" +
//                "FQC\t风险评估\tthe risk assessment\n" +
//                "IPQC\t制定跟踪方案\tinitiate Follow-up plan\n" +
//                "FPY\t制定跟踪方案\tinitiate Follow-up plan\n" +
//                "AQC\t结案\tclose the case\n" +
//                "TPY\t制定跟踪方案\tinitiate Follow-up plan\n" +
//                "XCSA\t短期改善措施\tshort-term solution\n" +
//                "LRR\t风险评估\tthe risk assessment\n" +
//                "FPY\t质量经理审批\tapproval by quality manager\n" +
//                "IQCSR\tIQC流程结束\tPROCESS ENDS\n" +
//                "BI\t效果验证一级审批\tLevel 1 Approval for Effect Test\n" +
//                "IQCF\t风险评估\tthe risk assessment\n" +
//                "IPQC\t效果验证一级审批\tLevel 1 Approval for Effect Test\n" +
//                "EE\t项目申请\tcase initiator\n" +
//                "CC\t效果验证一级审批\tLevel 1 Approval for Effect Test\n" +
//                "IQCF\t质量经理审批\tapproval by quality manager\n" +
//                "IQCF\t结案\tclose the case\n" +
//                "EE\t项目确认\tproject confirmation\n" +
//                "OOB\t风险评估\tthe risk assessment\n" +
//                "TPY\t效果验证\teffect test\n" +
//                "OOB\t质量经理审批\tapproval by quality manager\n" +
//                "OOB\t结案\tclose the case\n" +
//                "OOBR\t流程关闭\tproject close\n" +
//                "IQCF\t长期改善措施\tlong-term solution\n" +
//                "AQC\t效果验证\teffect test\n" +
//                "IQCF\t效果验证\teffect test\n" +
//                "AQC\t长期改善措施\tlong-term solution\n" +
//                "OOB\t效果验证\teffect test\n" +
//                "OOBR\t流程开始\tprocess initiator\n" +
//                "EE\t质量经理审批\tapproval by quality manager\n" +
//                "FQC\t长期改善措施\tlong-term solution\n" +
//                "FQC\t效果验证\teffect test\n" +
//                "TPY\t结案\tclose the case\n" +
//                "PD\t部门经理审批\tdepartment manager approval\n" +
//                "VLRR\t长期改善措施\tlong-term solution\n" +
//                "FPY\t长期改善措施\tlong-term solution\n" +
//                "LRR\t长期改善措施\tlong-term solution\n" +
//                "LRR\t制定跟踪方案\tinitiate Follow-up plan\n" +
//                "XCSA\t长期改善措施一级审批\tLevel 1 Approval for Long-term Solution\n" +
//                "AQC\t效果验证一级审批\tLevel 1 Approval for Effect Test\n" +
//                "WPSA\t基本信息录入\tbasic info entry\n" +
//                "WPSA\t结案\tclose the case\n" +
//                "EE\t部门经理确认\tdepartment manager approval\n" +
//                "WPSA\t风险评估\tthe risk assessment\n" +
//                "IPQC\t基本信息录入\tbasic info entry\n" +
//                "AQC\t短期改善措施\tshort-term solution\n" +
//                "TPY\t长期改善措施\tlong-term solution\n" +
//                "AQC\t质量经理审批\tapproval by quality manager\n" +
//                "IPQC\t结案\tclose the case\n" +
//                "EE\t项目改善\tproject improvement\n" +
//                "EE\t评审组评审\tproject review group review\n" +
//                "TPY\t基本信息录入\tbasic info entry\n" +
//                "WPSA\t长期改善措施\tlong-term solution\n" +
//                "PC\t接受部门审批\tACCEPT DEPARTMENT APPROVAL\n" +
//                "SI\t反馈工厂实际长期措施\tLocal Quality Actual Long Measures\n" +
//                "FQC\t短期改善措施\tshort-term solution\n" +
//                "WPSA\t短期改善措施\tshort-term solution\n" +
//                "FPY\t结案\tclose the case\n" +
//                "FQC\t结案\tclose the case\n" +
//                "FPY\t风险评估\tthe risk assessment\n" +
//                "TPY\t风险评估\tthe risk assessment\n" +
//                "VLRR\t风险评估\tthe risk assessment\n" +
//                "WPSA\t质量经理审批\tapproval by quality manager\n" +
//                "IPQC\t风险评估\tthe risk assessment\n" +
//                "WPSA\t制定跟踪方案\tinitiate Follow-up plan\n" +
//                "FQC\t制定跟踪方案\tinitiate Follow-up plan\n" +
//                "WPSA\t效果验证\teffect test\n" +
//                "FPY\t短期改善措施\tshort-term solution\n" +
//                "IPQC\t短期改善措施\tshort-term solution\n" +
//                "FQC\t质量经理审批\tapproval by quality manager\n" +
//                "LRR\t结案\tclose the case\n" +
//                "IPQC\t长期改善措施\tlong-term solution\n" +
//                "SI\tLocal Quality 审批长期措施\tLocal Quality Identify Long Measures\n" +
//                "IPQC\t效果验证\teffect test\n" +
//                "VLRR\t制定跟踪方案\tinitiate Follow-up plan\n" +
//                "FPY\t效果验证\teffect test\n" +
//                "VLRR\t质量经理审批\tapproval by quality manager\n" +
//                "IQC\tMRB会签\tMRB COUNTERSIGNED\n" +
//                "IQCF\t效果验证一级审批\tLevel 1 Approval for Effect Test\n" +
//                "IQC\t还检中\tUNDER INSPECTION\n" +
//                "OOB\t效果验证一级审批\tLevel 1 Approval for Effect Test\n" +
//                "FPY\t效果验证一级审批\tLevel 1 Approval for Effect Test\n" +
//                "IQC\t执行IQC检验\tPERFORM AN IQC TEST\n" +
//                "QH\t录入基本信息\tinput basic information\n" +
//                "TPY\t效果验证一级审批\tLevel 1 Approval for Effect Test\n" +
//                "XCSA\t质量经理审批\tapproval by quality manager\n" +
//                "OOBR\t流程结束\tProcess Ends\n" +
//                "XCSA\t效果验证\teffect test\n" +
//                "QH\t流程结束\tProcess Ends\n" +
//                "IC\t流程结束\tProcess Ends\n" +
//                "RWK\t流程结束\tProcess Ends\n" +
//                "PC\t流程结束\tProcess Ends\n" +
//                "BI\t流程结束\tProcess Ends\n" +
//                "CC\t流程结束\tProcess Ends\n" +
//                "PD\t流程结束\tProcess Ends\n" +
//                "LRR\t流程结束\tProcess Ends\n" +
//                "IQCF\t流程结束\tProcess Ends\n" +
//                "OOB\t流程结束\tProcess Ends\n" +
//                "FPY\t流程结束\tProcess Ends\n" +
//                "FQC\t流程结束\tProcess Ends\n" +
//                "EE\t流程结束\tProcess Ends\n" +
//                "WPSA\t流程结束\tProcess Ends\n" +
//                "IPQC\t流程结束\tProcess Ends\n" +
//                "TPY\t流程结束\tProcess Ends\n" +
//                "VLRR\t流程结束\tProcess Ends\n" +
//                "AQC\t流程结束\tProcess Ends\n" +
//                "OOB\t基本信息录入\tbasic info entry\n" +
//                "CC\t短期改善措施\tshort-term solution\n" +
//                "LRR\t短期改善措施\tshort-term solution\n" +
//                "AQC\t风险评估\tthe risk assessment\n" +
//                "CC\t风险评估\tthe risk assessment\n" +
//                "OOB\t长期改善措施\tlong-term solution\n" +
//                "XCSA\t制定跟踪方案\tinitiate Follow-up plan\n" +
//                "VLRR\t效果验证\teffect test\n" +
//                "LRR\t效果验证\teffect test\n" +
//                "EE\t效果验证\teffect test\n" +
//                "PD\t质量经理审批\tapproval by quality manager\n" +
//                "IPQC\t质量经理审批\tapproval by quality manager\n" +
//                "TPY\t质量经理审批\tapproval by quality manager\n" +
//                "LRR\t质量经理审批\tapproval by quality manager\n" +
//                "IQCF\t长期改善措施一级审批\tLevel 1 Approval for Long-term Solution\n" +
//                "QH\t解除Q-hold\tremove q-hold\n" +
//                "RWK\t部门经理审批\tdepartment manager approval\n" +
//                "XCSAR\t流程开始\tprocess initiator\n" +
//                "XCSAR\t流程关闭\tproject close\n" +
//                "IPQC\t短期改善措施一级审批\tLevel 1 Approval for Short-term Solution\n" +
//                "XCSA\t流程结束\tProcess Ends\n" +
//                "XCSAR\t流程结束\tProcess Ends\n" +
//                "XCSA\t长期改善措施\tlong-term solution\n" +
//                "IQCF\t制定跟踪方案\tinitiate Follow-up plan\n" +
//                "VLRR\t结案\tclose the case\n" +
//                "XCSA\t结案\tclose the case\n" +
//                "FPY\t长期改善措施一级审批\tLevel 1 Approval for Long-term Solution\n" +
//                "LRR\t长期改善措施一级审批\tLevel 1 Approval for Long-term Solution\n" +
//                "VLRR\t长期改善措施一级审批\tLevel 1 Approval for Long-term Solution\n" +
//                "IPQC\t长期改善措施一级审批\tLevel 1 Approval for Long-term Solution\n" +
//                "OOB\t长期改善措施一级审批\tLevel 1 Approval for Long-term Solution\n" +
//                "TPY\t长期改善措施一级审批\tLevel 1 Approval for Long-term Solution\n" +
//                "FQC\t长期改善措施一级审批\tLevel 1 Approval for Long-term Solution\n" +
//                "FQC\t效果验证一级审批\tLevel 1 Approval for Effect Test\n" +
//                "LRR\t效果验证一级审批\tLevel 1 Approval for Effect Test\n" +
//                "VLRR\t效果验证一级审批\tLevel 1 Approval for Effect Test\n" +
//                "XCSA\t效果验证一级审批\tLevel 1 Approval for Effect Test\n" +
//                "IQC\tIQC流程结束\tPROCESS ENDS\n" +
//                "IQC\tCQE确定最终检验结果\tCQE DETERMINES FINAL INSPECTION RESULTS\n" +
//                "IQC\tCQE复判\tCQE RETRIAL\n" +
//                "IQC\tHIC送货\tHIC DELIVERY\n" +
//                "IQC\t部件质量经理签批\tDEPARTMENT MANAGER APPROVAL\n" +
//                "SI\t结束\tEnd\n" +
//                "SI\tQES提交短期措施\tQES Provide  Short-term Solution\n" +
//                "SI\tLocal Quality 审批短期措施\tLocal Quality Identify Short Measures\n" +
//                "SI\t提交QES\tLocal Quality Submit Question to WW Quality\n" +
//                "SI\t反馈工厂实际短期措施\tLocal Quality Actual Short Measures\n" +
//                "SI\t短期效果验证\tLocal Quality Validation Short Measures\n" +
//                "SI\tQES提交长期措施\tWW Quality Provide Long Measures\n" +
//                "SI\t长期效果验证\tLocal Quality Validation Long Measures";
//
//        String sqlTemp = "update mail_issue_process set process_en_name ='%s' where  issue_code='%s' and process='%s';";
//        for(String line : text.split("\n")){
//            String  [] array = line.split("\t");
//            System.out.println(String.format(sqlTemp,array[2],array[0],array[1]));
//        }
//    }

    public static void main(String[] args) {
        String text ="Sub Issue process\tSI\tSub issue流程\n" +
                "XCSA closed-loop process\tXCSA\tXCSA闭环流程\n" +
                "XCSAR closed-loop process\tXCSAR\tXCSA复判任务流程\n" +
                "IQC Sorting Rework Details\tIQCSR\tIQC SORTINGREWORK\n" +
                "IQC task\tIQC\tIQC流程\n" +
                "OOB closed-loop process\tOOB\tOOB闭环流程\n" +
                "OOBR closed-loop process\tOOBR\tOOB复判任务流程\n" +
                "IQC closed-loop process\tIQCF\tIQC闭环问题\n" +
                "VLRR closed-loop process\tVLRR\tVLRR闭环流程\n" +
                "LRR closed-loop process\tLRR\tLRR闭环流程\n" +
                "FQC closed-loop process\tFQC\tFQC闭环流程\n" +
                "AQC closed-loop process\tAQC\tAQC闭环流程\n" +
                "TPY closed-loop process\tTPY\tTPY闭环流程\n" +
                "FPY closed-loop process\tFPY\tFPY闭环流程\n" +
                "IPQC closed-loop process\tIPQC\tIPQC闭环流程\n" +
                "eagle eye process\tEE\t鹰眼流程\n" +
                "preventive action process\tPD\t防患于未然流程\n" +
                "Q-HOLD process\tQH\t冻结流程管理\n" +
                "engineer flow modify process\tPC\t工艺变更流程\n" +
                "customer complaint closed-loop process\tCC\t客诉闭环流程\n" +
                "rework process\tRWK\t返工流程\n" +
                "batch closed-loop process\tBI\t批量闭环流程";

                String sqlTemp = "update mail_issue_manage set issue_en_name = '%s' where issue_code ='%s' and issue_name ='%s';";
                for(String line : text.split("\n")){
                    String  [] array = line.split("\t");
                    System.out.println(String.format(sqlTemp,array[0],array[1],array[2]));
                }
    }
}
